Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 19001 |
| Missing cells | 7531 |
| Missing cells (%) | 2.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.5 MiB |
| Average record size in memory | 136.0 B |
Variable types
| Numeric | 11 |
|---|---|
| Categorical | 5 |
| DateTime | 1 |
name has a high cardinality: 18780 distinct values | High cardinality |
host_name has a high cardinality: 6307 distinct values | High cardinality |
neighbourhood has a high cardinality: 215 distinct values | High cardinality |
last_review has 3758 (19.8%) missing values | Missing |
reviews_per_month has 3758 (19.8%) missing values | Missing |
minimum_nights is highly skewed (γ1 = 26.36588078) | Skewed |
df_index is uniformly distributed | Uniform |
name is uniformly distributed | Uniform |
df_index has unique values | Unique |
id has unique values | Unique |
number_of_reviews has 3758 (19.8%) zeros | Zeros |
availability_365 has 6970 (36.7%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-24 17:27:42.086048 |
|---|---|
| Analysis finished | 2023-04-24 17:27:56.652819 |
| Duration | 14.57 seconds |
| Software version | pandas-profiling v2.11.0 |
| Download configuration | config.yaml |
| Distinct | 19001 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10003.44161 |
|---|---|
| Minimum | 0 |
| Maximum | 19999 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1011 |
| Q1 | 5013 |
| median | 10005 |
| Q3 | 14995 |
| 95-th percentile | 19003 |
| Maximum | 19999 |
| Range | 19999 |
| Interquartile range (IQR) | 9982 |
Descriptive statistics
| Standard deviation | 5769.642118 |
|---|---|
| Coefficient of variation (CV) | 0.5767657116 |
| Kurtosis | -1.197212199 |
| Mean | 10003.44161 |
| Median Absolute Deviation (MAD) | 4991 |
| Skewness | -0.0006857784065 |
| Sum | 190075394 |
| Variance | 33288770.16 |
| Monotocity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 17714 | 1 | < 0.1% |
| 9518 | 1 | < 0.1% |
| 15661 | 1 | < 0.1% |
| 13612 | 1 | < 0.1% |
| 3371 | 1 | < 0.1% |
| 1322 | 1 | < 0.1% |
| 7465 | 1 | < 0.1% |
| 5416 | 1 | < 0.1% |
| 19747 | 1 | < 0.1% |
| Other values (18991) | 18991 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 |
| Value | Count | Frequency (%) |
| 19999 | 1 | |
| 19998 | 1 | |
| 19997 | 1 | |
| 19996 | 1 | |
| 19995 | 1 |
| Distinct | 19001 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18830405.22 |
|---|---|
| Minimum | 2539 |
| Maximum | 36485609 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | 2539 |
|---|---|
| 5-th percentile | 1177971 |
| Q1 | 9355498 |
| median | 19387536 |
| Q3 | 28919516 |
| 95-th percentile | 35240782 |
| Maximum | 36485609 |
| Range | 36483070 |
| Interquartile range (IQR) | 19564018 |
Descriptive statistics
| Standard deviation | 10969857.88 |
|---|---|
| Coefficient of variation (CV) | 0.5825609034 |
| Kurtosis | -1.225663309 |
| Mean | 18830405.22 |
| Median Absolute Deviation (MAD) | 9804926 |
| Skewness | -0.06687371468 |
| Sum | 3.577965297 × 1011 |
| Variance | 1.203377819 × 1014 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 32493112 | 1 | < 0.1% |
| 36308266 | 1 | < 0.1% |
| 15509545 | 1 | < 0.1% |
| 13073701 | 1 | < 0.1% |
| 20775370 | 1 | < 0.1% |
| 2728293 | 1 | < 0.1% |
| 169152 | 1 | < 0.1% |
| 3251638 | 1 | < 0.1% |
| 21308702 | 1 | < 0.1% |
| 8162587 | 1 | < 0.1% |
| Other values (18991) | 18991 |
| Value | Count | Frequency (%) |
| 2539 | 1 | |
| 3831 | 1 | |
| 5022 | 1 | |
| 5121 | 1 | |
| 5203 | 1 |
| Value | Count | Frequency (%) |
| 36485609 | 1 | |
| 36485057 | 1 | |
| 36480292 | 1 | |
| 36479723 | 1 | |
| 36478343 | 1 |
| Distinct | 18780 |
|---|---|
| Distinct (%) | 98.9% |
| Missing | 7 |
| Missing (%) | < 0.1% |
| Memory size | 148.6 KiB |
| Brooklyn Apartment | 7 |
|---|---|
| Hillside Hotel | 7 |
| Private Room | 6 |
| Home away from home | 6 |
| New york Multi-unit building | 5 |
| Other values (18775) |
Length
| Max length | 179 |
|---|---|
| Median length | 36 |
| Mean length | 36.75139518 |
| Min length | 1 |
Characters and Unicode
| Total characters | 698056 |
|---|---|
| Distinct characters | 504 |
| Distinct categories | 20 ? |
| Distinct scripts | 11 ? |
| Distinct blocks | 17 ? |
Unique
| Unique | 18619 ? |
|---|---|
| Unique (%) | 98.0% |
Sample
| 1st row | Private Lg Room 15 min to Manhattan |
|---|---|
| 2nd row | TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC |
| 3rd row | Voted #1 Location Quintessential 1BR W Village Apt |
| 4th row | Spacious 1 bedroom apartment 15min from Manhattan |
| 5th row | Big beautiful bedroom in huge Bushwick apartment |
| Value | Count | Frequency (%) |
| Brooklyn Apartment | 7 | < 0.1% |
| Hillside Hotel | 7 | < 0.1% |
| Private Room | 6 | < 0.1% |
| Home away from home | 6 | < 0.1% |
| New york Multi-unit building | 5 | < 0.1% |
| Cozy Room | 5 | < 0.1% |
| Private room in Manhattan | 5 | < 0.1% |
| Cozy Private Room | 4 | < 0.1% |
| Private room in Williamsburg | 4 | < 0.1% |
| private room | 3 | < 0.1% |
| Other values (18770) | 18942 | |
| (Missing) | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| in | 6594 | 5.7% |
| room | 4014 | 3.5% |
| 3161 | 2.7% | |
| bedroom | 3016 | 2.6% |
| private | 2874 | 2.5% |
| apartment | 2658 | 2.3% |
| cozy | 2017 | 1.7% |
| apt | 1765 | 1.5% |
| brooklyn | 1623 | 1.4% |
| studio | 1556 | 1.3% |
| Other values (6673) | 86285 |
Most occurring characters
| Value | Count | Frequency (%) |
| 97219 | 13.9% | |
| e | 48065 | 6.9% |
| o | 47895 | 6.9% |
| t | 40878 | 5.9% |
| a | 40431 | 5.8% |
| r | 38293 | 5.5% |
| i | 36980 | 5.3% |
| n | 36723 | 5.3% |
| l | 20035 | 2.9% |
| m | 19434 | 2.8% |
| Other values (494) | 272103 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 469006 | |
| Uppercase Letter | 102950 | 14.7% |
| Space Separator | 97221 | 13.9% |
| Other Punctuation | 12924 | 1.9% |
| Decimal Number | 9521 | 1.4% |
| Dash Punctuation | 2620 | 0.4% |
| Other Letter | 976 | 0.1% |
| Math Symbol | 970 | 0.1% |
| Close Punctuation | 621 | 0.1% |
| Open Punctuation | 568 | 0.1% |
| Other values (10) | 679 | 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 房 | 36 | 3.7% |
| 间 | 22 | 2.3% |
| 中 | 21 | 2.2% |
| 拉 | 19 | 1.9% |
| 法 | 18 | 1.8% |
| 盛 | 18 | 1.8% |
| 家 | 16 | 1.6% |
| 温 | 15 | 1.5% |
| 的 | 15 | 1.5% |
| 馨 | 13 | 1.3% |
| Other values (299) | 783 |
| Value | Count | Frequency (%) |
| e | 48065 | 10.2% |
| o | 47895 | 10.2% |
| t | 40878 | 8.7% |
| a | 40431 | 8.6% |
| r | 38293 | 8.2% |
| i | 36980 | 7.9% |
| n | 36723 | 7.8% |
| l | 20035 | 4.3% |
| m | 19434 | 4.1% |
| s | 18729 | 4.0% |
| Other values (48) | 121543 |
| Value | Count | Frequency (%) |
| ★ | 95 | |
| ❤ | 66 | |
| ☆ | 31 | 9.3% |
| ⭐ | 19 | 5.7% |
| ♥ | 14 | 4.2% |
| ✨ | 13 | 3.9% |
| ❥ | 13 | 3.9% |
| ✰ | 8 | 2.4% |
| ✿ | 7 | 2.1% |
| ☀ | 6 | 1.8% |
| Other values (27) | 61 |
| Value | Count | Frequency (%) |
| B | 11484 | 11.2% |
| S | 10080 | 9.8% |
| C | 8176 | 7.9% |
| A | 7545 | 7.3% |
| R | 6917 | 6.7% |
| P | 5740 | 5.6% |
| E | 5345 | 5.2% |
| L | 5288 | 5.1% |
| M | 4520 | 4.4% |
| N | 4373 | 4.2% |
| Other values (23) | 33482 |
| Value | Count | Frequency (%) |
| , | 3504 | |
| ! | 3055 | |
| / | 1958 | |
| . | 1683 | |
| & | 1234 | 9.5% |
| ' | 425 | 3.3% |
| * | 329 | 2.5% |
| : | 225 | 1.7% |
| # | 212 | 1.6% |
| " | 111 | 0.9% |
| Other values (9) | 188 | 1.5% |
| Value | Count | Frequency (%) |
| 1 | 3413 | |
| 2 | 2526 | |
| 3 | 931 | 9.8% |
| 5 | 800 | 8.4% |
| 0 | 768 | 8.1% |
| 4 | 459 | 4.8% |
| 6 | 233 | 2.4% |
| 8 | 150 | 1.6% |
| 7 | 147 | 1.5% |
| 9 | 94 | 1.0% |
| Value | Count | Frequency (%) |
| + | 476 | |
| | | 359 | |
| ~ | 99 | 10.2% |
| = | 11 | 1.1% |
| > | 9 | 0.9% |
| < | 7 | 0.7% |
| → | 6 | 0.6% |
| √ | 2 | 0.2% |
| × | 1 | 0.1% |
| Value | Count | Frequency (%) |
| ( | 544 | |
| [ | 16 | 2.8% |
| { | 4 | 0.7% |
| 【 | 3 | 0.5% |
| 《 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| ) | 596 | |
| ] | 17 | 2.7% |
| } | 4 | 0.6% |
| 】 | 3 | 0.5% |
| 》 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| - | 2589 | |
| — | 16 | 0.6% |
| – | 15 | 0.6% |
| Value | Count | Frequency (%) |
| 97219 | ||
| 2 | < 0.1% |
| Value | Count | Frequency (%) |
| ’ | 89 | |
| ” | 14 | 13.6% |
| Value | Count | Frequency (%) |
| ️ | 66 | |
| ︎ | 9 | 12.0% |
| Value | Count | Frequency (%) |
| “ | 15 | |
| ‘ | 4 | 21.1% |
| Value | Count | Frequency (%) |
| ゙ | 7 | |
| ー | 3 |
| Value | Count | Frequency (%) |
| ^ | 6 | |
| ` | 1 | 14.3% |
| Value | Count | Frequency (%) |
| 72 |
| Value | Count | Frequency (%) |
| $ | 34 |
| Value | Count | Frequency (%) |
| _ | 20 |
| Value | Count | Frequency (%) |
| ² | 6 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 571873 | |
| Common | 125049 | 17.9% |
| Han | 878 | 0.1% |
| Inherited | 75 | < 0.1% |
| Cyrillic | 71 | < 0.1% |
| Katakana | 45 | < 0.1% |
| Hebrew | 31 | < 0.1% |
| Georgian | 12 | < 0.1% |
| Hiragana | 12 | < 0.1% |
| Hangul | 8 | < 0.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| 房 | 36 | 4.1% |
| 间 | 22 | 2.5% |
| 中 | 21 | 2.4% |
| 拉 | 19 | 2.2% |
| 法 | 18 | 2.1% |
| 盛 | 18 | 2.1% |
| 家 | 16 | 1.8% |
| 温 | 15 | 1.7% |
| 的 | 15 | 1.7% |
| 馨 | 13 | 1.5% |
| Other values (244) | 685 |
| Value | Count | Frequency (%) |
| 97219 | ||
| , | 3504 | 2.8% |
| 1 | 3413 | 2.7% |
| ! | 3055 | 2.4% |
| - | 2589 | 2.1% |
| 2 | 2526 | 2.0% |
| / | 1958 | 1.6% |
| . | 1683 | 1.3% |
| & | 1234 | 1.0% |
| 3 | 931 | 0.7% |
| Other values (92) | 6937 | 5.5% |
| Value | Count | Frequency (%) |
| e | 48065 | 8.4% |
| o | 47895 | 8.4% |
| t | 40878 | 7.1% |
| a | 40431 | 7.1% |
| r | 38293 | 6.7% |
| i | 36980 | 6.5% |
| n | 36723 | 6.4% |
| l | 20035 | 3.5% |
| m | 19434 | 3.4% |
| s | 18729 | 3.3% |
| Other values (61) | 224410 |
| Value | Count | Frequency (%) |
| ン | 7 | |
| ト | 5 | 11.1% |
| ッ | 3 | 6.7% |
| タ | 3 | 6.7% |
| ウ | 3 | 6.7% |
| ク | 3 | 6.7% |
| ミ | 2 | 4.4% |
| ス | 2 | 4.4% |
| エ | 1 | 2.2% |
| サ | 1 | 2.2% |
| Other values (15) | 15 |
| Value | Count | Frequency (%) |
| а | 10 | |
| н | 7 | |
| т | 7 | |
| о | 6 | 8.5% |
| с | 6 | 8.5% |
| к | 5 | 7.0% |
| м | 4 | 5.6% |
| е | 4 | 5.6% |
| я | 3 | 4.2% |
| р | 3 | 4.2% |
| Other values (9) | 16 |
| Value | Count | Frequency (%) |
| י | 5 | |
| ו | 5 | |
| ב | 4 | |
| ר | 4 | |
| ע | 2 | 6.5% |
| ת | 2 | 6.5% |
| ה | 2 | 6.5% |
| ד | 1 | 3.2% |
| ש | 1 | 3.2% |
| ל | 1 | 3.2% |
| Other values (4) | 4 |
| Value | Count | Frequency (%) |
| 따 | 1 | |
| 뜻 | 1 | |
| 한 | 1 | |
| 작 | 1 | |
| 은 | 1 | |
| 건 | 1 | |
| 물 | 1 | |
| 웃 | 1 |
| Value | Count | Frequency (%) |
| の | 5 | |
| お | 2 | 16.7% |
| に | 1 | 8.3% |
| い | 1 | 8.3% |
| な | 1 | 8.3% |
| で | 1 | 8.3% |
| す | 1 | 8.3% |
| Value | Count | Frequency (%) |
| ️ | 66 | |
| ︎ | 9 | 12.0% |
| Value | Count | Frequency (%) |
| ॐ | 2 |
| Value | Count | Frequency (%) |
| ღ | 12 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 696288 | |
| CJK | 878 | 0.1% |
| Punctuation | 187 | < 0.1% |
| None | 179 | < 0.1% |
| Misc Symbols | 176 | < 0.1% |
| Dingbats | 130 | < 0.1% |
| VS | 75 | < 0.1% |
| Cyrillic | 71 | < 0.1% |
| Hebrew | 31 | < 0.1% |
| Georgian | 12 | < 0.1% |
| Other values (7) | 29 | < 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| 97219 | 14.0% | |
| e | 48065 | 6.9% |
| o | 47895 | 6.9% |
| t | 40878 | 5.9% |
| a | 40431 | 5.8% |
| r | 38293 | 5.5% |
| i | 36980 | 5.3% |
| n | 36723 | 5.3% |
| l | 20035 | 2.9% |
| m | 19434 | 2.8% |
| Other values (86) | 270335 |
| Value | Count | Frequency (%) |
| ❤ | 66 | |
| ✨ | 13 | 10.0% |
| ❥ | 13 | 10.0% |
| ✰ | 8 | 6.2% |
| ✿ | 7 | 5.4% |
| ✪ | 5 | 3.8% |
| ✴ | 4 | 3.1% |
| ✦ | 4 | 3.1% |
| ✮ | 3 | 2.3% |
| ✩ | 2 | 1.5% |
| Other values (3) | 5 | 3.8% |
| Value | Count | Frequency (%) |
| 房 | 36 | 4.1% |
| 间 | 22 | 2.5% |
| 中 | 21 | 2.4% |
| 拉 | 19 | 2.2% |
| 法 | 18 | 2.1% |
| 盛 | 18 | 2.1% |
| 家 | 16 | 1.8% |
| 温 | 15 | 1.7% |
| 的 | 15 | 1.7% |
| 馨 | 13 | 1.5% |
| Other values (244) | 685 |
| Value | Count | Frequency (%) |
| ’ | 89 | |
| • | 34 | 18.2% |
| — | 16 | 8.6% |
| – | 15 | 8.0% |
| “ | 15 | 8.0% |
| ” | 14 | 7.5% |
| ‘ | 4 | 2.1% |
| Value | Count | Frequency (%) |
| ★ | 95 | |
| ☆ | 31 | 17.6% |
| ♥ | 14 | 8.0% |
| ☀ | 6 | 3.4% |
| ♀ | 5 | 2.8% |
| ⚡ | 4 | 2.3% |
| ⚓ | 3 | 1.7% |
| ☺ | 3 | 1.7% |
| ♛ | 2 | 1.1% |
| ♕ | 2 | 1.1% |
| Other values (6) | 11 | 6.2% |
| Value | Count | Frequency (%) |
| ⭐ | 19 | 10.6% |
| à | 15 | 8.4% |
| ó | 9 | 5.0% |
| 。 | 7 | 3.9% |
| · | 7 | 3.9% |
| é | 7 | 3.9% |
| ゙ | 7 | 3.9% |
| ン | 7 | 3.9% |
| → | 6 | 3.4% |
| ² | 6 | 3.4% |
| Other values (51) | 89 |
| Value | Count | Frequency (%) |
| ॐ | 2 |
| Value | Count | Frequency (%) |
| ️ | 66 | |
| ︎ | 9 | 12.0% |
| Value | Count | Frequency (%) |
| ™ | 1 |
| Value | Count | Frequency (%) |
| √ | 2 |
| Value | Count | Frequency (%) |
| ღ | 12 |
| Value | Count | Frequency (%) |
| а | 10 | |
| н | 7 | |
| т | 7 | |
| о | 6 | 8.5% |
| с | 6 | 8.5% |
| к | 5 | 7.0% |
| м | 4 | 5.6% |
| е | 4 | 5.6% |
| я | 3 | 4.2% |
| р | 3 | 4.2% |
| Other values (9) | 16 |
| Value | Count | Frequency (%) |
| ▲ | 2 |
| Value | Count | Frequency (%) |
| の | 5 | |
| お | 2 | 16.7% |
| に | 1 | 8.3% |
| い | 1 | 8.3% |
| な | 1 | 8.3% |
| で | 1 | 8.3% |
| す | 1 | 8.3% |
| Value | Count | Frequency (%) |
| י | 5 | |
| ו | 5 | |
| ב | 4 | |
| ר | 4 | |
| ע | 2 | 6.5% |
| ת | 2 | 6.5% |
| ה | 2 | 6.5% |
| ד | 1 | 3.2% |
| ש | 1 | 3.2% |
| ל | 1 | 3.2% |
| Other values (4) | 4 |
| Value | Count | Frequency (%) |
| 따 | 1 | |
| 뜻 | 1 | |
| 한 | 1 | |
| 작 | 1 | |
| 은 | 1 | |
| 건 | 1 | |
| 물 | 1 | |
| 웃 | 1 |
| Value | Count | Frequency (%) |
| ⏩ | 1 | |
| ⏪ | 1 |
host_id
Real number (ℝ≥0)
| Distinct | 16241 |
|---|---|
| Distinct (%) | 85.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 66394588.99 |
|---|---|
| Minimum | 2571 |
| Maximum | 274273284 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | 2571 |
|---|---|
| 5-th percentile | 764688 |
| Q1 | 7728754 |
| median | 30487854 |
| Q3 | 104835356 |
| 95-th percentile | 239519185 |
| Maximum | 274273284 |
| Range | 274270713 |
| Interquartile range (IQR) | 97106602 |
Descriptive statistics
| Standard deviation | 77826632.15 |
|---|---|
| Coefficient of variation (CV) | 1.172183356 |
| Kurtosis | 0.2898665825 |
| Mean | 66394588.99 |
| Median Absolute Deviation (MAD) | 27185317 |
| Skewness | 1.245958822 |
| Sum | 1.261563585 × 1012 |
| Variance | 6.056984672 × 1015 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 219517861 | 117 | 0.6% |
| 107434423 | 71 | 0.4% |
| 30283594 | 44 | 0.2% |
| 137358866 | 36 | 0.2% |
| 12243051 | 36 | 0.2% |
| 61391963 | 34 | 0.2% |
| 16098958 | 33 | 0.2% |
| 22541573 | 32 | 0.2% |
| 26377263 | 24 | 0.1% |
| 2856748 | 22 | 0.1% |
| Other values (16231) | 18552 |
| Value | Count | Frequency (%) |
| 2571 | 1 | < 0.1% |
| 2787 | 3 | |
| 3151 | 1 | < 0.1% |
| 3415 | 1 | < 0.1% |
| 3563 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 274273284 | 1 | |
| 274195458 | 1 | |
| 274103383 | 1 | |
| 273870123 | 1 | |
| 273841667 | 1 |
| Distinct | 6307 |
|---|---|
| Distinct (%) | 33.2% |
| Missing | 8 |
| Missing (%) | < 0.1% |
| Memory size | 148.6 KiB |
| Michael | 159 |
|---|---|
| David | 157 |
| John | 130 |
| Sonder (NYC) | 117 |
| Alex | 98 |
| Other values (6302) |
Length
| Max length | 35 |
|---|---|
| Median length | 6 |
| Mean length | 6.100931922 |
| Min length | 1 |
Characters and Unicode
| Total characters | 115875 |
|---|---|
| Distinct characters | 138 |
| Distinct categories | 11 ? |
| Distinct scripts | 6 ? |
| Distinct blocks | 7 ? |
Unique
| Unique | 4077 ? |
|---|---|
| Unique (%) | 21.5% |
Sample
| 1st row | Iris |
|---|---|
| 2nd row | Johlex |
| 3rd row | John |
| 4th row | Regan |
| 5th row | Megan |
| Value | Count | Frequency (%) |
| Michael | 159 | 0.8% |
| David | 157 | 0.8% |
| John | 130 | 0.7% |
| Sonder (NYC) | 117 | 0.6% |
| Alex | 98 | 0.5% |
| Daniel | 92 | 0.5% |
| Sarah | 87 | 0.5% |
| Maria | 86 | 0.5% |
| Chris | 81 | 0.4% |
| Anna | 77 | 0.4% |
| Other values (6297) | 17909 |
| Value | Count | Frequency (%) |
| 401 | 1.9% | |
| and | 234 | 1.1% |
| michael | 175 | 0.8% |
| david | 169 | 0.8% |
| sonder | 153 | 0.7% |
| john | 145 | 0.7% |
| nyc | 122 | 0.6% |
| alex | 121 | 0.6% |
| laura | 117 | 0.6% |
| maria | 105 | 0.5% |
| Other values (5877) | 19369 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 14760 | 12.7% |
| e | 11187 | 9.7% |
| i | 9409 | 8.1% |
| n | 9394 | 8.1% |
| r | 6989 | 6.0% |
| l | 5914 | 5.1% |
| o | 4954 | 4.3% |
| t | 3638 | 3.1% |
| s | 3533 | 3.0% |
| h | 3518 | 3.0% |
| Other values (128) | 42579 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 91499 | |
| Uppercase Letter | 21211 | 18.3% |
| Space Separator | 2158 | 1.9% |
| Other Punctuation | 579 | 0.5% |
| Open Punctuation | 134 | 0.1% |
| Close Punctuation | 134 | 0.1% |
| Dash Punctuation | 76 | 0.1% |
| Other Letter | 39 | < 0.1% |
| Decimal Number | 30 | < 0.1% |
| Math Symbol | 14 | < 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| a | 14760 | |
| e | 11187 | |
| i | 9409 | |
| n | 9394 | |
| r | 6989 | 7.6% |
| l | 5914 | 6.5% |
| o | 4954 | 5.4% |
| t | 3638 | 4.0% |
| s | 3533 | 3.9% |
| h | 3518 | 3.8% |
| Other values (46) | 18203 |
| Value | Count | Frequency (%) |
| A | 2475 | |
| J | 2094 | 9.9% |
| M | 2051 | 9.7% |
| S | 1821 | 8.6% |
| C | 1432 | 6.8% |
| L | 1124 | 5.3% |
| D | 1079 | 5.1% |
| K | 1024 | 4.8% |
| R | 989 | 4.7% |
| E | 937 | 4.4% |
| Other values (22) | 6185 |
| Value | Count | Frequency (%) |
| 美 | 3 | 7.7% |
| 德 | 3 | 7.7% |
| 青 | 3 | 7.7% |
| 明 | 3 | 7.7% |
| 辣 | 2 | 5.1% |
| 柏 | 2 | 5.1% |
| 润 | 2 | 5.1% |
| 铀 | 2 | 5.1% |
| 泽 | 1 | 2.6% |
| 宇 | 1 | 2.6% |
| Other values (17) | 17 |
| Value | Count | Frequency (%) |
| & | 415 | |
| . | 122 | 21.1% |
| / | 14 | 2.4% |
| , | 13 | 2.2% |
| ' | 7 | 1.2% |
| ! | 4 | 0.7% |
| @ | 3 | 0.5% |
| : | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 5 | 7 | |
| 0 | 5 | |
| 7 | 5 | |
| 1 | 4 | |
| 2 | 3 | |
| 4 | 3 | |
| 6 | 2 | 6.7% |
| 3 | 1 | 3.3% |
| Value | Count | Frequency (%) |
| 2154 | ||
| 4 | 0.2% |
| Value | Count | Frequency (%) |
| ( | 134 |
| Value | Count | Frequency (%) |
| ) | 134 |
| Value | Count | Frequency (%) |
| - | 76 |
| Value | Count | Frequency (%) |
| + | 14 |
| Value | Count | Frequency (%) |
| £ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 112687 | |
| Common | 3126 | 2.7% |
| Han | 34 | < 0.1% |
| Cyrillic | 23 | < 0.1% |
| Hiragana | 3 | < 0.1% |
| Hangul | 2 | < 0.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| a | 14760 | 13.1% |
| e | 11187 | 9.9% |
| i | 9409 | 8.3% |
| n | 9394 | 8.3% |
| r | 6989 | 6.2% |
| l | 5914 | 5.2% |
| o | 4954 | 4.4% |
| t | 3638 | 3.2% |
| s | 3533 | 3.1% |
| h | 3518 | 3.1% |
| Other values (63) | 39391 |
| Value | Count | Frequency (%) |
| 2154 | ||
| & | 415 | 13.3% |
| ( | 134 | 4.3% |
| ) | 134 | 4.3% |
| . | 122 | 3.9% |
| - | 76 | 2.4% |
| + | 14 | 0.4% |
| / | 14 | 0.4% |
| , | 13 | 0.4% |
| 5 | 7 | 0.2% |
| Other values (13) | 43 | 1.4% |
| Value | Count | Frequency (%) |
| 美 | 3 | 8.8% |
| 德 | 3 | 8.8% |
| 青 | 3 | 8.8% |
| 明 | 3 | 8.8% |
| 辣 | 2 | 5.9% |
| 柏 | 2 | 5.9% |
| 润 | 2 | 5.9% |
| 铀 | 2 | 5.9% |
| 泽 | 1 | 2.9% |
| 宇 | 1 | 2.9% |
| Other values (12) | 12 |
| Value | Count | Frequency (%) |
| А | 3 | |
| е | 3 | |
| н | 2 | 8.7% |
| й | 2 | 8.7% |
| и | 2 | 8.7% |
| л | 2 | 8.7% |
| д | 1 | 4.3% |
| р | 1 | 4.3% |
| т | 1 | 4.3% |
| а | 1 | 4.3% |
| Other values (5) | 5 |
| Value | Count | Frequency (%) |
| ゆ | 1 | |
| り | 1 | |
| あ | 1 |
| Value | Count | Frequency (%) |
| 소 | 1 | |
| 정 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 115704 | |
| None | 105 | 0.1% |
| CJK | 34 | < 0.1% |
| Cyrillic | 23 | < 0.1% |
| Punctuation | 4 | < 0.1% |
| Hiragana | 3 | < 0.1% |
| Hangul | 2 | < 0.1% |
Most frequent character per block
| Value | Count | Frequency (%) |
| a | 14760 | 12.8% |
| e | 11187 | 9.7% |
| i | 9409 | 8.1% |
| n | 9394 | 8.1% |
| r | 6989 | 6.0% |
| l | 5914 | 5.1% |
| o | 4954 | 4.3% |
| t | 3638 | 3.1% |
| s | 3533 | 3.1% |
| h | 3518 | 3.0% |
| Other values (63) | 42408 |
| Value | Count | Frequency (%) |
| é | 42 | |
| á | 10 | 9.5% |
| í | 9 | 8.6% |
| ë | 8 | 7.6% |
| ô | 6 | 5.7% |
| è | 6 | 5.7% |
| ú | 5 | 4.8% |
| ó | 2 | 1.9% |
| ç | 2 | 1.9% |
| ı | 2 | 1.9% |
| Other values (12) | 13 | 12.4% |
| Value | Count | Frequency (%) |
| 美 | 3 | 8.8% |
| 德 | 3 | 8.8% |
| 青 | 3 | 8.8% |
| 明 | 3 | 8.8% |
| 辣 | 2 | 5.9% |
| 柏 | 2 | 5.9% |
| 润 | 2 | 5.9% |
| 铀 | 2 | 5.9% |
| 泽 | 1 | 2.9% |
| 宇 | 1 | 2.9% |
| Other values (12) | 12 |
| Value | Count | Frequency (%) |
| 4 |
| Value | Count | Frequency (%) |
| А | 3 | |
| е | 3 | |
| н | 2 | 8.7% |
| й | 2 | 8.7% |
| и | 2 | 8.7% |
| л | 2 | 8.7% |
| д | 1 | 4.3% |
| р | 1 | 4.3% |
| т | 1 | 4.3% |
| а | 1 | 4.3% |
| Other values (5) | 5 |
| Value | Count | Frequency (%) |
| ゆ | 1 | |
| り | 1 | |
| あ | 1 |
| Value | Count | Frequency (%) |
| 소 | 1 | |
| 정 | 1 |
neighbourhood_group
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 148.6 KiB |
| Brooklyn | |
|---|---|
| Manhattan | |
| Queens | |
| Bronx | 434 |
| Staten Island | 159 |
Length
| Max length | 13 |
|---|---|
| Median length | 8 |
| Mean length | 8.150623651 |
| Min length | 5 |
Characters and Unicode
| Total characters | 154870 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Queens |
|---|---|
| 2nd row | Manhattan |
| 3rd row | Manhattan |
| 4th row | Queens |
| 5th row | Brooklyn |
| Value | Count | Frequency (%) |
| Brooklyn | 8046 | |
| Manhattan | 8031 | |
| Queens | 2331 | 12.3% |
| Bronx | 434 | 2.3% |
| Staten Island | 159 | 0.8% |
| Value | Count | Frequency (%) |
| brooklyn | 8046 | |
| manhattan | 8031 | |
| queens | 2331 | 12.2% |
| bronx | 434 | 2.3% |
| island | 159 | 0.8% |
| staten | 159 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 27191 | |
| a | 24411 | |
| o | 16526 | |
| t | 16380 | |
| B | 8480 | 5.5% |
| r | 8480 | 5.5% |
| l | 8205 | 5.3% |
| k | 8046 | 5.2% |
| y | 8046 | 5.2% |
| M | 8031 | 5.2% |
| Other values (10) | 21074 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 135551 | |
| Uppercase Letter | 19160 | 12.4% |
| Space Separator | 159 | 0.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| n | 27191 | |
| a | 24411 | |
| o | 16526 | |
| t | 16380 | |
| r | 8480 | 6.3% |
| l | 8205 | 6.1% |
| k | 8046 | 5.9% |
| y | 8046 | 5.9% |
| h | 8031 | 5.9% |
| e | 4821 | 3.6% |
| Other values (4) | 5414 | 4.0% |
| Value | Count | Frequency (%) |
| B | 8480 | |
| M | 8031 | |
| Q | 2331 | 12.2% |
| S | 159 | 0.8% |
| I | 159 | 0.8% |
| Value | Count | Frequency (%) |
| 159 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 154711 | |
| Common | 159 | 0.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| n | 27191 | |
| a | 24411 | |
| o | 16526 | |
| t | 16380 | |
| B | 8480 | 5.5% |
| r | 8480 | 5.5% |
| l | 8205 | 5.3% |
| k | 8046 | 5.2% |
| y | 8046 | 5.2% |
| M | 8031 | 5.2% |
| Other values (9) | 20915 |
| Value | Count | Frequency (%) |
| 159 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 154870 |
Most frequent character per block
| Value | Count | Frequency (%) |
| n | 27191 | |
| a | 24411 | |
| o | 16526 | |
| t | 16380 | |
| B | 8480 | 5.5% |
| r | 8480 | 5.5% |
| l | 8205 | 5.3% |
| k | 8046 | 5.2% |
| y | 8046 | 5.2% |
| M | 8031 | 5.2% |
| Other values (10) | 21074 |
| Distinct | 215 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 148.6 KiB |
| Williamsburg | |
|---|---|
| Bedford-Stuyvesant | |
| Harlem | 1086 |
| Bushwick | 978 |
| Upper West Side | 734 |
| Other values (210) |
Length
| Max length | 26 |
|---|---|
| Median length | 12 |
| Mean length | 11.91947792 |
| Min length | 4 |
Characters and Unicode
| Total characters | 226482 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Sunnyside |
|---|---|
| 2nd row | Hell's Kitchen |
| 3rd row | West Village |
| 4th row | Astoria |
| 5th row | Bushwick |
| Value | Count | Frequency (%) |
| Williamsburg | 1526 | 8.0% |
| Bedford-Stuyvesant | 1478 | 7.8% |
| Harlem | 1086 | 5.7% |
| Bushwick | 978 | 5.1% |
| Upper West Side | 734 | 3.9% |
| East Village | 705 | 3.7% |
| Hell's Kitchen | 693 | 3.6% |
| Upper East Side | 667 | 3.5% |
| Crown Heights | 631 | 3.3% |
| Midtown | 505 | 2.7% |
| Other values (205) | 9998 |
| Value | Count | Frequency (%) |
| east | 2575 | 8.4% |
| side | 1756 | 5.7% |
| harlem | 1540 | 5.0% |
| williamsburg | 1526 | 5.0% |
| bedford-stuyvesant | 1478 | 4.8% |
| heights | 1427 | 4.7% |
| upper | 1401 | 4.6% |
| village | 1186 | 3.9% |
| west | 1033 | 3.4% |
| bushwick | 978 | 3.2% |
| Other values (227) | 15760 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 20714 | 9.1% |
| i | 16226 | 7.2% |
| s | 15652 | 6.9% |
| t | 15047 | 6.6% |
| a | 14816 | 6.5% |
| l | 13284 | 5.9% |
| r | 13260 | 5.9% |
| 11659 | 5.1% | |
| n | 10202 | 4.5% |
| o | 9383 | 4.1% |
| Other values (44) | 86239 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 179812 | |
| Uppercase Letter | 32558 | 14.4% |
| Space Separator | 11659 | 5.1% |
| Dash Punctuation | 1707 | 0.8% |
| Other Punctuation | 746 | 0.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 20714 | |
| i | 16226 | 9.0% |
| s | 15652 | 8.7% |
| t | 15047 | 8.4% |
| a | 14816 | 8.2% |
| l | 13284 | 7.4% |
| r | 13260 | 7.4% |
| n | 10202 | 5.7% |
| o | 9383 | 5.2% |
| d | 7624 | 4.2% |
| Other values (15) | 43604 |
| Value | Count | Frequency (%) |
| H | 4667 | |
| S | 4437 | |
| B | 3298 | |
| W | 3154 | |
| E | 2772 | |
| C | 2107 | 6.5% |
| G | 1464 | 4.5% |
| U | 1429 | 4.4% |
| F | 1324 | 4.1% |
| V | 1208 | 3.7% |
| Other values (14) | 6698 |
| Value | Count | Frequency (%) |
| ' | 697 | |
| . | 48 | 6.4% |
| , | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 11659 |
| Value | Count | Frequency (%) |
| - | 1707 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 212370 | |
| Common | 14112 | 6.2% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 20714 | 9.8% |
| i | 16226 | 7.6% |
| s | 15652 | 7.4% |
| t | 15047 | 7.1% |
| a | 14816 | 7.0% |
| l | 13284 | 6.3% |
| r | 13260 | 6.2% |
| n | 10202 | 4.8% |
| o | 9383 | 4.4% |
| d | 7624 | 3.6% |
| Other values (39) | 76162 |
| Value | Count | Frequency (%) |
| 11659 | ||
| - | 1707 | 12.1% |
| ' | 697 | 4.9% |
| . | 48 | 0.3% |
| , | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 226482 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 20714 | 9.1% |
| i | 16226 | 7.2% |
| s | 15652 | 6.9% |
| t | 15047 | 6.6% |
| a | 14816 | 6.5% |
| l | 13284 | 5.9% |
| r | 13260 | 5.9% |
| 11659 | 5.1% | |
| n | 10202 | 4.5% |
| o | 9383 | 4.1% |
| Other values (44) | 86239 |
latitude
Real number (ℝ≥0)
| Distinct | 12087 |
|---|---|
| Distinct (%) | 63.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.72806312 |
|---|---|
| Minimum | 40.50873 |
| Maximum | 40.91306 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | 40.50873 |
|---|---|
| 5-th percentile | 40.64456 |
| Q1 | 40.68882 |
| median | 40.72171 |
| Q3 | 40.76321 |
| 95-th percentile | 40.82645 |
| Maximum | 40.91306 |
| Range | 0.40433 |
| Interquartile range (IQR) | 0.07439 |
Descriptive statistics
| Standard deviation | 0.05538931047 |
|---|---|
| Coefficient of variation (CV) | 0.001359978998 |
| Kurtosis | 0.05864487992 |
| Mean | 40.72806312 |
| Median Absolute Deviation (MAD) | 0.03659 |
| Skewness | 0.2542518047 |
| Sum | 773873.9274 |
| Variance | 0.003067975714 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.72232 | 8 | < 0.1% |
| 40.69414 | 8 | < 0.1% |
| 40.68634 | 8 | < 0.1% |
| 40.71813 | 8 | < 0.1% |
| 40.72607 | 7 | < 0.1% |
| 40.68084 | 7 | < 0.1% |
| 40.68683 | 7 | < 0.1% |
| 40.70741 | 6 | < 0.1% |
| 40.72522 | 6 | < 0.1% |
| 40.72276 | 6 | < 0.1% |
| Other values (12077) | 18930 |
| Value | Count | Frequency (%) |
| 40.50873 | 1 | |
| 40.52293 | 1 | |
| 40.53871 | 1 | |
| 40.53939 | 1 | |
| 40.54106 | 1 |
| Value | Count | Frequency (%) |
| 40.91306 | 1 | |
| 40.90527 | 1 | |
| 40.90391 | 1 | |
| 40.90356 | 1 | |
| 40.90329 | 1 |
longitude
Real number (ℝ)
| Distinct | 9944 |
|---|---|
| Distinct (%) | 52.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -73.95082679 |
|---|---|
| Minimum | -74.23914 |
| Maximum | -73.71795 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | -74.23914 |
|---|---|
| 5-th percentile | -74.00369 |
| Q1 | -73.98205 |
| median | -73.95463 |
| Q3 | -73.93449 |
| 95-th percentile | -73.86186 |
| Maximum | -73.71795 |
| Range | 0.52119 |
| Interquartile range (IQR) | 0.04756 |
Descriptive statistics
| Standard deviation | 0.04682498719 |
|---|---|
| Coefficient of variation (CV) | -0.0006331908543 |
| Kurtosis | 4.824279693 |
| Mean | -73.95082679 |
| Median Absolute Deviation (MAD) | 0.02489 |
| Skewness | 1.234020827 |
| Sum | -1405139.66 |
| Variance | 0.002192579425 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| -73.95742 | 9 | < 0.1% |
| -73.95427 | 9 | < 0.1% |
| -73.95121 | 9 | < 0.1% |
| -73.95725 | 9 | < 0.1% |
| -73.98589 | 9 | < 0.1% |
| -73.94829 | 9 | < 0.1% |
| -73.95677 | 8 | < 0.1% |
| -73.94524 | 8 | < 0.1% |
| -73.9398 | 8 | < 0.1% |
| -73.95149 | 8 | < 0.1% |
| Other values (9934) | 18915 |
| Value | Count | Frequency (%) |
| -74.23914 | 1 | |
| -74.21238 | 1 | |
| -74.19626 | 1 | |
| -74.18259 | 1 | |
| -74.17628 | 1 |
| Value | Count | Frequency (%) |
| -73.71795 | 1 | |
| -73.71829 | 1 | |
| -73.72582 | 1 | |
| -73.72716 | 1 | |
| -73.72731 | 1 |
room_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 148.6 KiB |
| Entire home/apt | |
|---|---|
| Private room | |
| Shared room | 438 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 13.48034314 |
| Min length | 11 |
Characters and Unicode
| Total characters | 256140 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Private room |
|---|---|
| 2nd row | Entire home/apt |
| 3rd row | Entire home/apt |
| 4th row | Entire home/apt |
| 5th row | Private room |
| Value | Count | Frequency (%) |
| Entire home/apt | 9522 | |
| Private room | 9041 | |
| Shared room | 438 | 2.3% |
| Value | Count | Frequency (%) |
| home/apt | 9522 | |
| entire | 9522 | |
| room | 9479 | |
| private | 9041 | |
| shared | 438 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 28523 | |
| r | 28480 | |
| o | 28480 | |
| t | 28085 | |
| a | 19001 | 7.4% |
| 19001 | 7.4% | |
| m | 19001 | 7.4% |
| i | 18563 | 7.2% |
| h | 9960 | 3.9% |
| E | 9522 | 3.7% |
| Other values (7) | 47524 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 208616 | |
| Uppercase Letter | 19001 | 7.4% |
| Space Separator | 19001 | 7.4% |
| Other Punctuation | 9522 | 3.7% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 28523 | |
| r | 28480 | |
| o | 28480 | |
| t | 28085 | |
| a | 19001 | |
| m | 19001 | |
| i | 18563 | |
| h | 9960 | 4.8% |
| n | 9522 | 4.6% |
| p | 9522 | 4.6% |
| Other values (2) | 9479 | 4.5% |
| Value | Count | Frequency (%) |
| E | 9522 | |
| P | 9041 | |
| S | 438 | 2.3% |
| Value | Count | Frequency (%) |
| 19001 |
| Value | Count | Frequency (%) |
| / | 9522 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 227617 | |
| Common | 28523 | 11.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 28523 | |
| r | 28480 | |
| o | 28480 | |
| t | 28085 | |
| a | 19001 | |
| m | 19001 | |
| i | 18563 | |
| h | 9960 | 4.4% |
| E | 9522 | 4.2% |
| n | 9522 | 4.2% |
| Other values (5) | 28480 |
| Value | Count | Frequency (%) |
| 19001 | ||
| / | 9522 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 256140 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 28523 | |
| r | 28480 | |
| o | 28480 | |
| t | 28085 | |
| a | 19001 | 7.4% |
| 19001 | 7.4% | |
| m | 19001 | 7.4% |
| i | 18563 | 7.2% |
| h | 9960 | 3.9% |
| E | 9522 | 3.7% |
| Other values (7) | 47524 |
price
Real number (ℝ≥0)
| Distinct | 321 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 122.3404558 |
|---|---|
| Minimum | 10 |
| Maximum | 350 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 66 |
| median | 100 |
| Q3 | 160 |
| 95-th percentile | 270 |
| Maximum | 350 |
| Range | 340 |
| Interquartile range (IQR) | 94 |
Descriptive statistics
| Standard deviation | 71.53034564 |
|---|---|
| Coefficient of variation (CV) | 0.5846826807 |
| Kurtosis | 0.5028006941 |
| Mean | 122.3404558 |
| Median Absolute Deviation (MAD) | 45 |
| Skewness | 1.027024411 |
| Sum | 2324591 |
| Variance | 5116.590347 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 856 | 4.5% |
| 150 | 821 | 4.3% |
| 50 | 636 | 3.3% |
| 200 | 590 | 3.1% |
| 75 | 570 | 3.0% |
| 60 | 555 | 2.9% |
| 80 | 531 | 2.8% |
| 70 | 482 | 2.5% |
| 120 | 471 | 2.5% |
| 65 | 471 | 2.5% |
| Other values (311) | 13018 |
| Value | Count | Frequency (%) |
| 10 | 6 | |
| 11 | 2 | < 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 350 | 147 | |
| 349 | 14 | 0.1% |
| 348 | 1 | < 0.1% |
| 347 | 2 | < 0.1% |
| 346 | 1 | < 0.1% |
| Distinct | 75 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.906899637 |
|---|---|
| Minimum | 1 |
| Maximum | 1250 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 5 |
| 95-th percentile | 30 |
| Maximum | 1250 |
| Range | 1249 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 21.45654397 |
|---|---|
| Coefficient of variation (CV) | 3.10653768 |
| Kurtosis | 1156.455229 |
| Mean | 6.906899637 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 26.36588078 |
| Sum | 131238 |
| Variance | 460.3832792 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 5003 | |
| 2 | 4619 | |
| 3 | 3086 | |
| 30 | 1442 | 7.6% |
| 4 | 1253 | 6.6% |
| 5 | 1140 | 6.0% |
| 7 | 822 | 4.3% |
| 6 | 285 | 1.5% |
| 14 | 210 | 1.1% |
| 10 | 178 | 0.9% |
| Other values (65) | 963 | 5.1% |
| Value | Count | Frequency (%) |
| 1 | 5003 | |
| 2 | 4619 | |
| 3 | 3086 | |
| 4 | 1253 | 6.6% |
| 5 | 1140 | 6.0% |
| Value | Count | Frequency (%) |
| 1250 | 1 | |
| 999 | 2 | |
| 480 | 1 | |
| 400 | 1 | |
| 370 | 1 |
| Distinct | 321 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.79774749 |
|---|---|
| Minimum | 0 |
| Maximum | 607 |
| Zeros | 3758 |
| Zeros (%) | 19.8% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 6 |
| Q3 | 24 |
| 95-th percentile | 116 |
| Maximum | 607 |
| Range | 607 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 45.49345456 |
|---|---|
| Coefficient of variation (CV) | 1.911670614 |
| Kurtosis | 19.56592146 |
| Mean | 23.79774749 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 3.706018813 |
| Sum | 452181 |
| Variance | 2069.654408 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3758 | |
| 1 | 2022 | 10.6% |
| 2 | 1342 | 7.1% |
| 3 | 975 | 5.1% |
| 4 | 796 | 4.2% |
| 5 | 589 | 3.1% |
| 6 | 544 | 2.9% |
| 7 | 495 | 2.6% |
| 8 | 449 | 2.4% |
| 9 | 383 | 2.0% |
| Other values (311) | 7648 |
| Value | Count | Frequency (%) |
| 0 | 3758 | |
| 1 | 2022 | |
| 2 | 1342 | 7.1% |
| 3 | 975 | 5.1% |
| 4 | 796 | 4.2% |
| Value | Count | Frequency (%) |
| 607 | 1 | |
| 594 | 1 | |
| 510 | 1 | |
| 488 | 1 | |
| 474 | 1 |
| Distinct | 1494 |
|---|---|
| Distinct (%) | 9.8% |
| Missing | 3758 |
| Missing (%) | 19.8% |
| Memory size | 148.6 KiB |
| Minimum | 2011-05-12 00:00:00 |
|---|---|
| Maximum | 2019-07-08 00:00:00 |
| Distinct | 789 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 3758 |
| Missing (%) | 19.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.380927639 |
|---|---|
| Minimum | 0.01 |
| Maximum | 27.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | 0.01 |
|---|---|
| 5-th percentile | 0.04 |
| Q1 | 0.19 |
| median | 0.72 |
| Q3 | 2.01 |
| 95-th percentile | 4.69 |
| Maximum | 27.95 |
| Range | 27.94 |
| Interquartile range (IQR) | 1.82 |
Descriptive statistics
| Standard deviation | 1.689988413 |
|---|---|
| Coefficient of variation (CV) | 1.22380664 |
| Kurtosis | 11.9516004 |
| Mean | 1.380927639 |
| Median Absolute Deviation (MAD) | 0.62 |
| Skewness | 2.435330583 |
| Sum | 21049.48 |
| Variance | 2.856060837 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.02 | 362 | 1.9% |
| 1 | 352 | 1.9% |
| 0.05 | 333 | 1.8% |
| 0.03 | 323 | 1.7% |
| 0.04 | 268 | 1.4% |
| 0.08 | 256 | 1.3% |
| 0.16 | 244 | 1.3% |
| 0.09 | 235 | 1.2% |
| 0.06 | 226 | 1.2% |
| 0.11 | 217 | 1.1% |
| Other values (779) | 12427 | |
| (Missing) | 3758 | 19.8% |
| Value | Count | Frequency (%) |
| 0.01 | 17 | 0.1% |
| 0.02 | 362 | |
| 0.03 | 323 | |
| 0.04 | 268 | |
| 0.05 | 333 |
| Value | Count | Frequency (%) |
| 27.95 | 1 | |
| 20.94 | 1 | |
| 19.75 | 1 | |
| 17.82 | 1 | |
| 16.22 | 1 |
calculated_host_listings_count
Real number (ℝ≥0)
| Distinct | 47 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.583811378 |
|---|---|
| Minimum | 1 |
| Maximum | 327 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 13 |
| Maximum | 327 |
| Range | 326 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 31.15475023 |
|---|---|
| Coefficient of variation (CV) | 4.732023511 |
| Kurtosis | 77.21481439 |
| Mean | 6.583811378 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.461222905 |
| Sum | 125099 |
| Variance | 970.6184621 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 12627 | |
| 2 | 2605 | 13.7% |
| 3 | 1123 | 5.9% |
| 4 | 539 | 2.8% |
| 5 | 345 | 1.8% |
| 6 | 208 | 1.1% |
| 7 | 165 | 0.9% |
| 8 | 164 | 0.9% |
| 327 | 117 | 0.6% |
| 9 | 98 | 0.5% |
| Other values (37) | 1010 | 5.3% |
| Value | Count | Frequency (%) |
| 1 | 12627 | |
| 2 | 2605 | 13.7% |
| 3 | 1123 | 5.9% |
| 4 | 539 | 2.8% |
| 5 | 345 | 1.8% |
| Value | Count | Frequency (%) |
| 327 | 117 | |
| 232 | 71 | |
| 121 | 44 | 0.2% |
| 103 | 36 | 0.2% |
| 96 | 69 |
| Distinct | 366 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 109.7253829 |
|---|---|
| Minimum | 0 |
| Maximum | 365 |
| Zeros | 6970 |
| Zeros (%) | 36.7% |
| Memory size | 148.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 39 |
| Q3 | 219 |
| 95-th percentile | 358 |
| Maximum | 365 |
| Range | 365 |
| Interquartile range (IQR) | 219 |
Descriptive statistics
| Standard deviation | 130.5998995 |
|---|---|
| Coefficient of variation (CV) | 1.190243279 |
| Kurtosis | -0.9348291358 |
| Mean | 109.7253829 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 0.8027018468 |
| Sum | 2084892 |
| Variance | 17056.33374 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6970 | |
| 365 | 432 | 2.3% |
| 364 | 195 | 1.0% |
| 1 | 176 | 0.9% |
| 5 | 133 | 0.7% |
| 3 | 115 | 0.6% |
| 2 | 113 | 0.6% |
| 179 | 112 | 0.6% |
| 89 | 111 | 0.6% |
| 6 | 110 | 0.6% |
| Other values (356) | 10534 |
| Value | Count | Frequency (%) |
| 0 | 6970 | |
| 1 | 176 | 0.9% |
| 2 | 113 | 0.6% |
| 3 | 115 | 0.6% |
| 4 | 107 | 0.6% |
| Value | Count | Frequency (%) |
| 365 | 432 | |
| 364 | 195 | |
| 363 | 88 | 0.5% |
| 362 | 62 | 0.3% |
| 361 | 44 | 0.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | availability_365 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 9138664 | Private Lg Room 15 min to Manhattan | 47594947 | Iris | Queens | Sunnyside | 40.74271 | -73.92493 | Private room | 74 | 2 | 6 | 2019-05-26 | 0.13 | 1 | 5 |
| 1 | 1 | 31444015 | TIME SQUARE CHARMING ONE BED IN HELL'S KITCHEN,NYC | 8523790 | Johlex | Manhattan | Hell's Kitchen | 40.76682 | -73.98878 | Entire home/apt | 170 | 3 | 0 | NaT | NaN | 1 | 188 |
| 2 | 2 | 8741020 | Voted #1 Location Quintessential 1BR W Village Apt | 45854238 | John | Manhattan | West Village | 40.73631 | -74.00611 | Entire home/apt | 245 | 3 | 51 | 2018-09-19 | 1.12 | 1 | 0 |
| 3 | 3 | 34602077 | Spacious 1 bedroom apartment 15min from Manhattan | 261055465 | Regan | Queens | Astoria | 40.76424 | -73.92351 | Entire home/apt | 125 | 3 | 1 | 2019-05-24 | 0.65 | 1 | 13 |
| 4 | 4 | 23203149 | Big beautiful bedroom in huge Bushwick apartment | 143460 | Megan | Brooklyn | Bushwick | 40.69839 | -73.92044 | Private room | 65 | 2 | 8 | 2019-06-23 | 0.52 | 2 | 8 |
| 5 | 5 | 4402805 | LRG 2br BKLYN APT CLOSE TO TRAINS AND PARK | 22807362 | Jenny | Brooklyn | Prospect-Lefferts Gardens | 40.66025 | -73.96270 | Entire home/apt | 120 | 3 | 3 | 2018-08-28 | 0.05 | 1 | 16 |
| 6 | 6 | 30070126 | ✩Prime Renovated 1/1 Apartment in Upper East Side✩ | 4968673 | Sean | Manhattan | Upper East Side | 40.76831 | -73.95929 | Entire home/apt | 200 | 5 | 2 | 2019-05-26 | 0.68 | 1 | 71 |
| 7 | 7 | 34231172 | Fully renovated brick house floor in Brooklyn | 59642348 | Kevin | Brooklyn | Sunset Park | 40.64550 | -74.01262 | Entire home/apt | 95 | 1 | 9 | 2019-07-08 | 9.00 | 1 | 106 |
| 8 | 8 | 5856760 | Renovated 1BR in exciting, convenient area | 29408349 | Chad | Manhattan | Chinatown | 40.71490 | -73.99976 | Entire home/apt | 179 | 5 | 7 | 2017-04-18 | 0.14 | 1 | 0 |
| 9 | 9 | 7929441 | Beautiful Loft w/ Waterfront View! | 1453898 | Anthony | Brooklyn | Williamsburg | 40.71268 | -73.96676 | Private room | 105 | 2 | 232 | 2019-06-19 | 5.00 | 3 | 64 |
Last rows
| df_index | id | name | host_id | host_name | neighbourhood_group | neighbourhood | latitude | longitude | room_type | price | minimum_nights | number_of_reviews | last_review | reviews_per_month | calculated_host_listings_count | availability_365 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18991 | 19990 | 5192459 | Quiet Room in 4BR UWS Brownstone | 10677483 | Greg | Manhattan | Upper West Side | 40.80173 | -73.96625 | Private room | 70 | 1 | 0 | NaT | NaN | 1 | 0 |
| 18992 | 19991 | 1327940 | Huge Gorgeous Park View Apartment! | 3290436 | Hadar | Brooklyn | Flatbush | 40.65335 | -73.96257 | Entire home/apt | 120 | 3 | 13 | 2016-08-27 | 0.28 | 2 | 327 |
| 18993 | 19992 | 23612681 | Shared Room 1 Stop from Manhattan on the F Train | 55724558 | Taylor | Queens | Long Island City | 40.76006 | -73.94080 | Private room | 55 | 4 | 2 | 2019-06-01 | 0.65 | 5 | 89 |
| 18994 | 19993 | 34485745 | Midtown Manhattan Stunner - Private room | 261632622 | Royalton | Manhattan | Theater District | 40.75491 | -73.98507 | Private room | 100 | 1 | 3 | 2019-06-16 | 3.00 | 9 | 318 |
| 18995 | 19994 | 25616250 | Stylish, spacious, private 1BR apt in Ditmas Park | 125396920 | Adam | Brooklyn | Flatbush | 40.64314 | -73.95705 | Entire home/apt | 75 | 3 | 10 | 2019-01-03 | 0.84 | 1 | 0 |
| 18996 | 19995 | 7094539 | Tranquil haven in bubbly Brooklyn | 2052211 | Adriana | Brooklyn | Windsor Terrace | 40.65360 | -73.97546 | Entire home/apt | 143 | 14 | 2 | 2016-08-27 | 0.04 | 1 | 10 |
| 18997 | 19996 | 4424261 | Large 1 BR with backyard on UWS | 3447311 | Sarah | Manhattan | Upper West Side | 40.80188 | -73.96808 | Entire home/apt | 200 | 2 | 22 | 2019-05-21 | 0.50 | 1 | 0 |
| 18998 | 19997 | 4545882 | Amazing studio/Loft with a backyard | 23569951 | Kaveh | Manhattan | Upper East Side | 40.78110 | -73.94567 | Entire home/apt | 220 | 3 | 28 | 2019-05-23 | 0.50 | 1 | 293 |
| 18999 | 19998 | 26518547 | U2 comfortable double bed sleeps 2 guests | 295128 | Carol Gloria | Bronx | Clason Point | 40.81225 | -73.85502 | Private room | 80 | 1 | 4 | 2019-07-01 | 1.48 | 7 | 365 |
| 19000 | 19999 | 33631782 | Private Bedroom in Williamsburg Apt! | 8569221 | Andi | Brooklyn | Williamsburg | 40.71829 | -73.95819 | Private room | 109 | 3 | 3 | 2019-04-28 | 1.07 | 2 | 97 |